<?php

$line = array('MAC', 'TEXT_DEUTSCH', 'TEXT_ENGLISH');
$csv->addRow($line);

$textd = "Achtung: Dieses Modem wird per Mass Modem Swap Tool ausgetauscht. Bitte keinen manuellen Tausch veranlassen.";
$texte = "Attention: This modem will be swapped by the mass modem swap tool. Please do not perform a manual swap.";

WHILE($r = mysql_fetch_array($result))
  {
    $line = array($r['mac'], $textd ,$texte);
    $csv->addRow($line);
    
    $bid = $r['id'];
    mysql_query("UPDATE blacklists SET ctsp = 2 WHERE id = '$bid'");
  }

$datum = date("d.m.Y");
$end = ".csv";
$title = "Export_Blacklist_CTSP_".$datum.".csv";
echo $csv->render($title);


?>